<?php
// +----------------------------------------------------------------------
// | 中联致远服务端框架
// +----------------------------------------------------------------------
// | Copyright (c) 2018 http://www.zhongliansoft.com All rights reserved.
// +----------------------------------------------------------------------
// | Author: tony <tanyu@zhongliansoft.com>
// +----------------------------------------------------------------------

namespace app\common\model;
use think\Db;
use think\facade\Log;

class BookCommon extends Common
{
    // 获取年度列表
    public function getYears()
    {
        $sql = "select * from zl_view_get_years ";
        $list = Db::query($sql);       //返回的数据格式化，并渲染成table所需要的最终的显示数据类型
        return $list;
    }

    // 获设设置年度列表
    public function getSettingYears()
    {
        $sql = "select * from zl_view_get_setting_years ";
        $list = Db::query($sql);       //返回的数据格式化，并渲染成table所需要的最终的显示数据类型
        return $list;
    }

    // 获取季度列表
    public function getSeasons()
    {
        $sql = "select * from zl_view_get_seasons ";
        $list = Db::query($sql);
        return $list;
    }

    // 获取季度列表
    public function getDepts()
    {
        $sql = "select * from zl_view_get_depts ";
        $list = Db::query($sql);
        return $list;
    }

    // 获取季度列表
    public function getSpecialities()
    {
        $sql = "select * from zl_view_get_specicalties ";
        $list = Db::query($sql);
        return $list;
    }

    // 获取班级列表
    public function getClasses()
    {
        $sql = "select * from zl_view_get_classes ";
        $list = Db::query($sql);
        return $list;
    }

    // 获取方向列表
    public function getDirs()
    {
        $sql = "select * from zl_view_get_dirs ";
        $list = Db::query($sql);
        return $list;
    }

    // 获取所有辅导员列表
    public function getTeachers()
    {
        $sql = "select * from zl_view_get_teachers ";
        $list = Db::query($sql);
        return $list;
    }
}